HousingLease

EntityType | Independent
Logical Entity Name | HousingLease
Default Table Name | HSStudentLeaseHistory
Logical Only | NO
Owner | dbo
Definition |
Note |

HousingLease Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
HSStudentLeaseHistoryID |  | INTEGER | NO |
StartDate |  | DATETIME | NO |
MoveOutDate |  | DATETIME | YES |
EndDate |  | DATETIME | NO |
ActualEndDate |  | DATETIME | YES |
AdTermID |  | INTEGER | YES |
HSLeaseStatusID |  | INTEGER | NO |
SyStudentID |  | INTEGER | NO |
HSBuildingRoomsID |  | INTEGER | NO |
HSStudentApplicationID |  | INTEGER | NO |
HSMoveOutReasonID |  | INTEGER | YES |
LeaseAmount |  | MONEY(19, 4) | NO |
Frequency |  | CHAR(1) | NO |
TerminationFee |  | MONEY(19, 4) | YES |
SaBillCodeID |  | INTEGER | YES |
UserID |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
ts |  | TIMESTAMP/DATE | NO |
LastPrintDate |  | DATETIME | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
FaStudentAYID |  | INTEGER | YES |
Reason |  | VARCHAR(max) | YES |
DateSelectedOn |  | CHAR(1) | YES |
IsAcademicYearLease |  | BIT | NO |
SaTransCodeID |  | INTEGER | YES |
SaBillTermID |  | INTEGER | YES |
ManuallyUpdateDates |  | BIT | NO |
LastFrequency |  | CHAR(1) | YES |
RoomSwitchDate |  | DATETIME | YES |
StartDateOnRoomSwitch |  | DATETIME | YES |

HousingLease Keys

Key Name | Key Type | Keys
HSStudentLeaseHistory_HSMoveOutReasonID_N_N_IDX | Inversion Entry | HSMoveOutReasonID
HSStudentLeaseHistory_HSLeaseStatusID_N_N_IDX | Inversion Entry | HSLeaseStatusID
HSStudentLeaseHistory_AdTermID_N_N_IDX | Inversion Entry | AdTermID
HSStudentLeaseHistory_HSBuildingRoomsID_NU_NC_IDX | Inversion Entry | HSBuildingRoomsID
HSStudentLeaseHistory_SyStudentID_N_N_IDX | Inversion Entry | SyStudentID
HSStudentLeaseHistory_SaBillCodeID_N_N_IDX | Inversion Entry | SaBillCodeID
HSStudentLeaseHistory_HSStudentApplicationID_N_N_IDX | Inversion Entry | HSStudentApplicationID
HSStudentLeaseHistory_StartDate_EndDate_NU_NC_IDX | Inversion Entry | StartDate, EndDate
HSStudentLeaseHistory_HSStudentLeaseHistoryID_U_C_IDX | PrimaryKey | HSStudentLeaseHistoryID

HousingLease Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | AdTermID | NO
HsBuildingRooms | Non-Identifying | One To Zero or More |  |  |  | HSBuildingRoomsID | NO
HSLeaseStatus | Non-Identifying | One To Zero or More |  |  |  | HSLeaseStatusID | NO
HSMoveOutReason | Non-Identifying | Zero or One to Zero or More |  |  |  | HSMoveOutReasonID | NO
HousingApplicationStudent | Non-Identifying | One To Zero or More |  |  |  | HSStudentApplicationID | NO
BillingTransactionCode | Non-Identifying | Zero or One to Zero or More |  |  |  | SaBillCodeID | NO
Student | Non-Identifying | One To Zero or More |  |  |  | SyStudentID | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
StudentAcademicYear | Non-Identifying | Zero or One to Zero or More |  |  |  | FaStudentAYID | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | SaBillTermID | NO
BillingTransactionCode | Non-Identifying | Zero or One to Zero or More |  |  |  | SaTransCodeID | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
HsBuildingRoomsStudents | Non-Identifying | One To Zero or More |  |  |  |  | NO
HousingLeaseScheduledCharge | Non-Identifying | One To Zero or More |  |  |  |  | NO
HousingLeaseDocument | Non-Identifying | One To Zero or More |  |  |  |  | NO
HSStudentLeaseEvent | Non-Identifying | One To Zero or More |  |  |  |  | NO

HousingLease Check Constraints

Check Constraint Name | CheckConstraint

HousingLease Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.HousingLease | NO |  |  |
Physical (Microsoft SQL Server) dbo.HSStudentLeaseHistory | NO |  |  |

HousingLease Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Housing

HousingLease Data Movement Rules

Name | Type | Rule Text/Value